Round 1 - Technical (Live Coding)

This round began with a brief introduction and focused on live coding with the following questions:

🔹 SQL window functions.

🔹 Output-based questions where I was shown an output and asked to write the SQL query to achieve that result.

🔹 SQL functions like `COALESCE` and handling null values in string columns during joins.

🔹 Count of joins involving null and numerical values.

🔹 Python string and array-based coding questions, which were medium to easy level.

🔹 PySpark code to pass a schema while reading data.

🔹 PySpark code to create a new column based on conditions.

🔹 Spark optimization techniques.

🔹 Questions on Spark architecture.

🔹 AWS-related questions on Glue, Lambda, S3, and project-related cross-questioning.

Round 2 - Techno-Managerial 

This round was also conducted online and included:

🔹 How to optimize an SQL query.

🔹 Spark optimization techniques.

🔹 Questions on pandas and numpy, focusing on transformation functions.

🔹 In-depth discussion on data engineering-related professional and personal projects, including cross-questioning.

🔹 Situation-based managerial questions (non-technical).

🔹 Why I was interested in joining BMS (they were looking for good reasons).

Round 3 - HR Discussion

🔹Salary Negotiation.

🔹Variable component discussion.

I received the offer letter after the final HR round..😊